OpenEdge Development:<br />Basic Database Tools Auditing reports

Auditing reports

Choose Reports Auditing Reports to access the Auditing Reports submenu. For a description of each auditing report, see Table 8–3. For a complete description of OpenEdge auditing events and event IDs, see OpenEdge Getting Started: Core Business Services .

Track Audit Policy Changes

The Track Audit Policy Changes report details audit policy maintenance, commit, and dump/load events.

To generate a Track Audit Policy Changes report:

Choose Reports

Auditing Reports

Track Audit Policy Changes. The Date Range dialog box appears.

To specify a range of dates on which to report, select Select Some and enter the dates in the Start Range and End Range fields. To report on all audit policy records, select Select All.

Choose OK. The OpenEdge Auditing Report Options dialog box appears. See the "OpenEdge Auditing Report Options dialog box" section for more information about the OpenEdge Auditing Report Options dialog box.

Track Database Schema Changes

The Track Database Schema Changes report details schema modification actions such as creating tables and modifying sequence definitions.

To generate a Track Database Schema Changes report:

Choose Reports

Auditing Reports

Track Database Schema Changes. The Date Range dialog box appears.

Track Audit Data Administration (Dump/Load)

The Track Audit Data Administration (Dump/Load) report details the dump, load, and archival of audit data.

To generate a Track Audit Data Administration (Dump/Load) report:

Choose the Reports

Auditing Reports

Track Audit Data Administration (Dump/Load). The Date Range dialog box appears.

Track Application Data Administration (Dump/Load)

The Track Application Data Administration (Dump/Load) report details the dump and load of application data.

To generate a Track Application Data Administration (Dump/Load) report:

Choose Reports

Auditing Reports

Track Application Data Administration (Dump/Load).The Date Range dialog box appears.

Track User Account Changes

The Track User Account Changes report details changes to the _user table and lists the user ID of the user who made the changes.

To generate a Track User Account Changes report:

Choose Reports

Auditing Reports

Track User Account Changes. The Date Range dialog box appears.

Track Security Permissions Changes

The Track Security Permissions Changes report details role maintenance and permissions maintenance events.

To generate a Track Security Permissions Changes report:

Choose Reports

Auditing Reports

Track Security Permissions Changes. The Date Range dialog box appears.

Track SQL Permissions Changes

The Track SQL Permissions Changes report details create, update, and delete events, as well as the user ID of the user who made the change.

To generate a Track SQL Permissions Changes report:

Choose Reports

Auditing Reports

Track SQL Permissions Changes. The Date Range dialog box appears.

Track Authentication System Changes

The Track Authentication System Changes report details authentication system maintenance events and authentication system domain maintenance events.

To generate a Track Authentication System Changes report:

Choose Reports

Auditing Reports

Track Authentication System Changes.The Date Range dialog box appears.

Client Session Authentication

The Client Session Authentication report details application access through authentication domains.

To generate a Client Session Authentication report:

Choose Reports

Auditing Reports

Client Session Authentication.The Date Range dialog box appears.

Database Administration Report (Utilities)

The Database Administration report details activities performed by command-line database administration utilities.

To generate a Database Administration Report (Utilities):

Choose Reports

Auditing Reports

Database Administration Report (Utilities).The Date Range dialog box appears.

Database Access Report (Login/Logout/etc)

The Database Access report details login and logout events performed on an OpenEdge database.

To generate a Database Access Report (Login/Logout/etc):

Choose Reports

Auditing Reports

Database Access Report (Login/Logout/etc).The Date Range dialog box appears.

Custom Audit Data Filter Report

The Custom Audit Data Filter report allows you to limit the amount of audit data on which the Data Dictionary tool reports.

To generate an audit report using the Custom Audit Data Filter:

Choose Reports

Auditing Reports

Custom Audit Data Filter Report. The Custom Audit Data Filter dialog box appears.

To filter based on audit date range, complete the following fields:

From Date — The date of the earliest audit transaction you want reported on.

To Date — The date of the last audit transaction you want reported on.

To filter based on audit event id range, complete the following fields:

From Id — The first id you want reported on.

To Id — The last id you want reported on.

To report on audit events associated with a user Id, enter the Id into the Miscellaneous User Id field.

To report on audit events associated with a transaction Id, enter the Id into the Miscellaneous Transaction Id field.

To filter on event context information, complete the desired context field:

System Context — The system context you want reported on. The system context is typically the name of a table. Select SEP to insert a separator character. The separator character indicates a delimited string.

Policy Context — The policy context you want reported on. Select SEP to insert a separator character. The separator character indicates a delimited string.

Use the BEGINS, MATCHES, and EQUALS options to filter the Event Context information.

Note: If you filter on Event Context information, the report may take a long time to generate.

OpenEdge Auditing Report Options dialog box

The OpenEdge Auditing Report Options dialog box allows you to set display characteristics for your auditing report. The OpenEdge Auditing Report Options dialog box contains the following fields:

Send Output to — Choose the output destination from the radio set: Terminal, File (XML), or File (Text).

File Name — If File (XML) or File (Text) is the selected output destination, enter a file name for the report or browse for a file using Files.

Append to Existing File — Select to append an existing file. If not selected, an existing file may be overwritten.

Page Length — Enter a number. Zero (0) creates continuous output with no line breaks. The default is 60 lines per printed page. The default for a terminal is the number of lines displayed on the screen.

Orientation — Select the report’s orientation: Detail or Summary. Select Detail if you want details for each of the report’s entries. Select Summary if you only want to print summary information.